package br.com.massai.model.dao.jdbc;

import java.io.Serializable;
import java.sql.SQLException;
import java.util.List;

import javax.ejb.Local;

import br.com.massai.model.entity.Department;
import br.com.massai.model.entity.file.FunctionEmployee;
import br.com.massai.model.entity.pojo.Employee;
import br.com.massai.model.exceptions.SystemException;

@Local
public interface EmployeeRepository extends Serializable {

	public List<Employee> findAll() throws SystemException, SQLException, Throwable;
	public List<Employee> findByDepartment(Department department) throws SystemException, SQLException, Throwable;
	public List<Employee> findByDepartment(Department department, String name) throws SystemException, SQLException, Exception;
	public Employee findID(String empCodigo, String epgCodigo) throws SystemException, SQLException, Throwable;
	public Employee findIDAll(String empCodigo, String epgCodigo) throws SystemException, SQLException;
	public String findFunctionName(String code) throws SystemException, SQLException;
	public List<FunctionEmployee> findFunctionNameByEmp(String codeEmp) throws SystemException, SQLException;
	public String findEventoName(String code) throws SystemException, SQLException;

}